This is probably one of the posts that never will be completed, as the tools I use change over time. However at the moment this is an overview of the tools I use and how to find them.
DBA Tools | Community driven SQL Server PowerShell module, which continously gets more functions and features. |
Ola Hallengren Maintenance Solution | The maintenance tool to help you automate the maintenance you absolutely need! |
sp_WhoIsActive | A comprehensive activity monitoring sp, which is a helpful troubleshooting partner. Created by Adam Machanic |
sp_Blitz | Discover your database servers possibilities for improvement. Created by Brent Ozar |
SQL Server Diagnostic Queries | Magnificent DMV Queries which will provide you with information you did not even thought you wanted. Created by Glenn Berry |
DBAChecks | You probably need to validate your environment, and this is a good tool for it. |
SQL Server Management Studio | Perhaps a given, but it is the main tool used by most DBAs I would recon. |
Azure Data Studio | Azure Data Studio (previously SQL Server Operations Studio), a tool focusing on getting an overview and documenting stuff. |
Microsoft Update Catalog | Good to have should you need to patch servers offline. |
Execution Plan Reference | SQL Server Execution Plan Reference Created by Hugo Kornelis |
Wait Types | SQL Server Wait Types Library Created by SQLSkills |
Latch Classes | SQL Server Latch Classes Library Created by SQLSkills |